Skip to main content

Output From The Estimating Form

The Estimator Add-in assists the user in uploading a staged revision that can be used to compute a new revision when they wish to publish a proposal, upload a buyout, create a change order, etc.

Global Attributes​

  • SolutionId
  • Default Waste
  • Price Type

Materials​

Materials are defined within the ID's sheet.

The uploaded columns include:

  • ID
  • Supplier
  • SKU
  • Description
  • Unit
  • Unit/CTN
  • Depth
  • Width
  • Length
  • Unit Price (This is scheduled to be removed from staging)
  • Frt Y/N
  • Frt Amt
  • Cost Used
  • Dealer
  • N-S Cost
  • Extra
info

Qty Needed is used to trim empty rows and reduce payload size. And all (x/y/z). ids are ignored as they are the form's implementation of generated materials.

Activities​

Activities are defined within the Room Schedule sheet.

The uploaded columns include:

  • Location
  • Room
  • Area
  • Method
  • Installation
  • Demo
  • W/P
  • Notes
  • ID
  • Joint Size
  • Type
  • Grout
  • Phase
  • User Tot
  • Qty
  • Labor Rate
  • Set Cover
info

Rows that have 'NA' for ID or 0 for Qty will be ignored.

User Totals​

User Totals are defined within the User Totals sheet.

The uploaded columns include:

  • Area Description
  • Area #
  • Included In Total
  • Area Total
  • Sealer *
  • Anti Fracture *
  • Water Proof *
  • Demo/ Removal *
info

Rows that have an Area Description that is equal to 'User Totals' or starts with 'Combined Totals' is ignored.